Creating or changing columns of data

GVPT399F: Power, Politics, and Data

Add new variables with mutate()

mutate(gapminder, gdp = gdpPercap * pop)
# A tibble: 1,704 × 7
   country     continent  year lifeExp      pop gdpPercap          gdp
   <fct>       <fct>     <int>   <dbl>    <int>     <dbl>        <dbl>
 1 Afghanistan Asia       1952    28.8  8425333      779.  6567086330.
 2 Afghanistan Asia       1957    30.3  9240934      821.  7585448670.
 3 Afghanistan Asia       1962    32.0 10267083      853.  8758855797.
 4 Afghanistan Asia       1967    34.0 11537966      836.  9648014150.
 5 Afghanistan Asia       1972    36.1 13079460      740.  9678553274.
 6 Afghanistan Asia       1977    38.4 14880372      786. 11697659231.
 7 Afghanistan Asia       1982    39.9 12881816      978. 12598563401.
 8 Afghanistan Asia       1987    40.8 13867957      852. 11820990309.
 9 Afghanistan Asia       1992    41.7 16317921      649. 10595901589.
10 Afghanistan Asia       1997    41.8 22227415      635. 14121995875.
# ℹ 1,694 more rows

Change existing columns

mutate(gapminder, gdpPercap = log(gdpPercap))
# A tibble: 1,704 × 6
   country     continent  year lifeExp      pop gdpPercap
   <fct>       <fct>     <int>   <dbl>    <int>     <dbl>
 1 Afghanistan Asia       1952    28.8  8425333      6.66
 2 Afghanistan Asia       1957    30.3  9240934      6.71
 3 Afghanistan Asia       1962    32.0 10267083      6.75
 4 Afghanistan Asia       1967    34.0 11537966      6.73
 5 Afghanistan Asia       1972    36.1 13079460      6.61
 6 Afghanistan Asia       1977    38.4 14880372      6.67
 7 Afghanistan Asia       1982    39.9 12881816      6.89
 8 Afghanistan Asia       1987    40.8 13867957      6.75
 9 Afghanistan Asia       1992    41.7 16317921      6.48
10 Afghanistan Asia       1997    41.8 22227415      6.45
# ℹ 1,694 more rows

Select, transform, and add new variables with transmute()

transmute(gapminder, country, year, gdp = gdpPercap * pop)
# A tibble: 1,704 × 3
   country      year          gdp
   <fct>       <int>        <dbl>
 1 Afghanistan  1952  6567086330.
 2 Afghanistan  1957  7585448670.
 3 Afghanistan  1962  8758855797.
 4 Afghanistan  1967  9648014150.
 5 Afghanistan  1972  9678553274.
 6 Afghanistan  1977 11697659231.
 7 Afghanistan  1982 12598563401.
 8 Afghanistan  1987 11820990309.
 9 Afghanistan  1992 10595901589.
10 Afghanistan  1997 14121995875.
# ℹ 1,694 more rows